prepare("select * from inventory_main where date_in BETWEEN '$date1' and '$date2' ") ; $getrec->execute() ; //get sum $gsum = $DBcon->prepare("select sum(gross_total) as gcost from inventory_main where date_in BETWEEN '$date1' and '$date2' ") ; $gsum->execute() ; $gsrow = $gsum->fetch(pdo::FETCH_ASSOC) ; $tsum = $gsrow['gcost'] ; $count = 0 ; while($row = $getrec->fetch(pdo::FETCH_ASSOC)) { $count++ ; ?>

SN	INVENTORY_ID	DATE IN	AMOUNT
		Grand Total